Paul Newcome
Paul Newcome
-
Re: Can Free Users add or edit records via the details pane of a Dynamic View?
Anyone that has access to the DV should be able to edit so long as you have those fields set to be editable in the DV settings. Same with adding rows. Anyone that has access should be able to add row…1 · -
Re: Help with INDEX/COLLECT with a MAX/COLLECT
In that case you will need to insert a helper column that houses the MAX/COLLECT, and then you would reference this column in the OR function.1 · -
Re: Viewing a Smartsheet form submission in the form it was submitted through
If you open the row menu and select "Edit", the fields will be displayed in a vertical format more like a form.1 · -
Re: I am getting an invalid data type when the IF function pulls the false statement which is blank inst
My next guess would be that there are instances where your INDEX/MATCHes aren't pulling in dates. This could also throw that error when using date based functions such as YEAR, MONTH, and DAY. Try wr…1 · -
Re: change cell value with SUBSTITUTE formula
In that case, you would use an INDEX/MATCH. =INDEX({Reference Sheet Name Column}, MATCH([Column2]@row, {Reference Sheet Match Column}, 0))1 ·
